SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451143 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451143 [ RunTime:0.002116s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837831,149879,647189,572226,202068,288440,1002984,326390,359236,356392,272038,495824,854817,145175,836833,139084,889821,431272,488254,981451,783007,838320,283201,352697,819223,400710,843891,200813,868411,170402,876584,106389,518511,950701,327598,982175,16833,890344,175108,767925,568418,1003175,547472,858182,390811,122105,832405,661915,636659,230608,469088,132201,288839,182761,602357,154227,94591,62406,609521,447790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]