SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402548 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402548 [ RunTime:0.002207s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734212,736647,1017477,434656,184953,566370,518234,133093,470922,641820,441315,318254,316578,775113,599263,908717,340798,74904,664906,577075,1006876,942429,362578,905741,871161,380780,435487,841767,879953,189369,830730,971413,234136,425162,736806,986534,620514,34534,804177,934676,414994,606133,1026321,761870,974101,199642,981217,815670,180062,654674,849968,970816,405996,67532,866647,243569,167068,122087,327937,924356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402548 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402548 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001620s ]