SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313815 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313815 [ RunTime:0.001519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (792483,793076,465151,349883,45237,779844,838152,305987,363354,523515,354184,585193,1005275,81837,705071,493208,142254,891436,249439,638004,1033218,949783,742465,874596,67790,426474,725463,1025898,93635,300137,892540,578810,588730,916699,467204,91941,82923,771802,768192,369532,290569,665658,185869,695910,234940,293272,241312,665264,197629,22732,20174,570945,267562,113670,231659,747262,993012,303764,580643,200473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]