SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001770s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 153193 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 153193 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012600,372953,1034287,940696,370032,362700,750602,321537,920569,1040087,609335,565359,265989,454518,816980,503590,888560,991204,673970,392017,233868,1007986,405335,282834,457983,136832,685610,271752,724336,282489,962826,158799,1036588,685285,252603,140705,462751,812195,682600,282212,204166,432159,527716,594939,655385,420589,953423,744094,840944,275771,45410,50256,365455,496087,336042,256684,957689,927942,195120,141392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 153193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 153193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]