SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002458s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431629 LIMIT 1 [ RunTime:0.000828s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431629 [ RunTime:0.003079s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820019,238796,641821,1014260,939241,737269,1030745,1029642,362913,968046,572176,672654,832891,534113,266857,960369,445673,976254,621866,265892,23459,705404,131562,436050,414957,220029,689113,104563,565792,842581,860984,860820,711718,661013,648885,703514,812072,656273,24275,925467,708734,717889,324860,498176,504419,554596,253988,59559,316568,94059,687240,346368,911828,253868,121651,465581,28531,122220,755390,51959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431629 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431629 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]