SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429384 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429384 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (746740,471292,744861,743459,662619,912640,290029,78908,446157,85144,341990,703544,500822,754127,74820,638069,1011770,275377,311663,904409,984670,765214,917852,395527,37669,962410,813867,305699,83673,660952,285319,832215,986758,272963,863755,581129,240917,878259,670979,401826,403118,815061,664184,450968,1028229,766768,417712,842733,780201,629286,1012487,394854,360861,741168,629941,912059,547835,447770,787715,760340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429384 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429384 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]