SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 819300 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 819300 [ RunTime:0.001499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031013,443080,211846,18581,45025,929841,194255,542185,676823,1009798,419543,1034183,98152,352455,130173,306702,866637,859753,359050,506779,970496,1029158,756230,133679,284711,819404,9888,301068,89232,50886,301649,453390,767736,205569,69883,64321,88929,581244,243070,791410,616857,36680,873143,369898,673621,792705,829522,272686,829668,804646,869285,227752,473362,937700,170997,149709,263737,558938,231352,805362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 819300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 819300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]