SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 143328 LIMIT 1 [ RunTime:0.000597s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 143328 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588925,99137,239839,363233,476840,333163,365749,439465,271922,6324,970934,57627,519032,365404,10109,393284,661955,858459,255407,682142,1001172,607711,885472,122680,88689,994874,122238,782003,202977,776746,476742,691945,189485,788647,117254,175667,951567,1021804,51638,907254,6402,248412,888440,516854,820526,15920,962673,565950,703043,425982,728405,310343,301888,495446,372450,523211,279028,225438,940671,380744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 143328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 143328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]