SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42083 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42083 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (758411,603818,101861,33679,946904,1015263,331441,235543,93893,239366,16816,703661,192251,86761,12532,577587,318392,90218,262676,951389,79073,633234,283683,615410,571475,888436,45129,309123,407275,624839,302839,104549,731316,311847,747227,816269,1015559,182737,831925,193472,819702,248064,980809,693122,770461,960413,471246,19504,840085,242416,413879,640686,696814,1023580,146624,417824,450821,50681,382080,508351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]