SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020326 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020326 [ RunTime:0.002134s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (922271,459254,666068,362281,151714,267507,307534,885138,1041637,542678,321288,511203,971211,568824,945583,887312,509120,789873,32390,382282,642480,293362,437554,590069,523070,826194,1047401,470411,533472,349592,384088,574269,831034,516062,926291,84360,825644,649444,306409,22701,491980,977615,745459,997522,805464,118788,899177,803988,1003674,163071,397866,921078,633323,989735,678266,994234,953704,98803,1018152,1026994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020326 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020326 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001242s ]