SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290791 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290791 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879838,727386,638146,466275,509499,167144,593178,948173,426972,282058,387448,410850,700432,426327,407475,210189,201149,136030,940985,787478,589060,1000781,900562,721145,470946,155061,567482,53294,139255,147314,76738,903200,563566,408556,660643,156378,498788,254220,792254,490957,829457,896981,390223,295620,918351,29767,558953,85563,868960,90241,130439,665556,187872,5308,1022441,358520,316080,394136,317902,636059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]