SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541837 LIMIT 1 [ RunTime:0.001729s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541837 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964488,246928,108613,127879,286193,169165,726903,78536,104923,629536,844841,1023369,51949,720352,233343,1034319,589623,567011,1025391,100065,331680,1040774,985723,246889,179186,272451,543329,854754,86633,650894,885982,7102,942963,687476,915636,920620,177357,8944,925835,998208,398729,312013,877856,12986,293597,776683,510392,992915,661847,798437,485116,674196,481284,81657,39123,1009825,240690,93285,519061,741236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541837 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541837 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]