SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585003 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585003 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039408,126105,735435,462898,790710,647427,219707,272083,212225,712875,259196,85211,439441,320064,702532,752360,596172,971452,821057,238211,959354,542132,1042442,955571,973174,136460,1029513,298447,315546,204102,624126,1040052,70717,281670,402307,661128,267563,342388,748277,106952,50409,514305,75696,127063,46847,349738,123602,405794,369247,147832,907221,98245,983597,246368,901642,522263,1010411,620677,402675,443861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]