SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006924s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411960 LIMIT 1 [ RunTime:0.000841s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411960 [ RunTime:0.001978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153785,792,165588,288153,636222,308104,1032535,638312,788797,979269,119056,397245,418755,9794,241938,84824,71079,261529,261501,387986,657537,568526,885740,699778,443649,953116,238993,810000,897329,990067,537875,332808,409857,650548,942144,71326,56516,465060,955496,773054,184810,877678,559007,719674,869688,200709,168446,252725,121384,687406,591959,374810,630722,371525,241545,730313,25110,313479,781597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411960 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411960 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]