SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802451 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802451 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024823,234875,18081,1000115,86950,225662,577988,66665,177744,965093,1011441,210309,89100,404376,830031,877820,131948,68300,9336,1021072,144950,522321,480665,867310,1041328,946016,691506,785783,152280,279378,892588,598404,853937,457223,611862,741038,870514,95342,441896,361998,408181,905904,49967,996184,1000928,822241,953173,290663,312956,874466,507020,511325,680074,261815,737729,25359,657975,387595,748290,753724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]