SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313535 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313535 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46787,274456,952479,212255,448415,694813,962332,156849,950616,808706,47385,491460,531519,781728,201658,691828,413578,117692,6099,102942,207218,572343,352852,89152,866031,100989,896796,742914,796879,882484,307501,784795,305227,564874,904131,903244,339862,523149,67578,667115,499840,1100,635470,372031,816535,248229,968919,3832,611063,14062,30303,293226,669594,340570,659397,217988,823979,204597,1017347,755624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]