SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018102 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018102 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250885,974341,354813,597185,743135,101593,136265,586884,30681,543766,759150,491570,1021235,1001215,219984,256899,942450,1003273,601337,313128,167841,544678,777259,325384,886186,123912,519574,31997,1021980,23764,473533,922778,191191,47636,206522,734090,690489,174887,1020220,939138,147270,201109,633563,852496,355611,531921,109749,47007,403099,114173,712263,570816,173682,689570,655419,817997,534498,253348,881949,249359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]