SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 271822 LIMIT 1 [ RunTime:0.000677s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 271822 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533778,34260,504447,66439,808466,1015193,36706,807167,665010,108060,585657,412623,370682,986006,343811,740809,1041243,80569,521959,709170,370810,480440,710893,148672,948165,429585,589312,308657,571043,663406,269007,980455,532047,331239,689553,509448,619756,303590,182245,872808,792950,438732,591416,715711,359151,205817,859584,987807,116543,249298,792270,843861,444729,1028024,923104,117832,875978,224148,299700,407811) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003659s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 271822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 271822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000890s ]