SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 271418 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 271418 [ RunTime:0.005632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527151,233206,679278,48104,970661,378087,454757,313846,435998,486164,435001,205375,539484,311485,1047200,181663,20943,291994,794071,746993,777594,100139,913740,509859,294703,56019,58127,471611,760454,361614,136029,302475,235814,211253,986373,837197,1015943,718520,416325,135533,274607,901467,763802,383998,28001,576231,13214,384940,503483,2777,90648,773542,797992,501945,580843,139016,348107,135863,781045,572558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 271418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 271418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000381s ]