SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522986 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522986 [ RunTime:0.002772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459715,152596,604750,237683,509857,982637,1047717,17792,327813,275092,516483,611325,221089,172338,425801,518184,880198,641162,1000961,135870,757561,359143,846802,425888,512806,683370,726082,99462,341069,484788,237459,473096,504173,852058,597886,499905,892441,253796,252525,501001,842832,444966,264723,288493,602155,327644,979641,191766,356904,264690,369327,230146,142325,263585,871243,597122,12048,781030,464554,493382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001831s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]