SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451083 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451083 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126953,139729,306080,774898,191877,437985,230965,647940,227322,658826,35020,470394,650633,775601,804110,243122,346611,137290,1002850,40326,463207,523685,352583,913748,797362,421215,718791,61870,857003,653494,898145,649608,287574,671581,216399,281525,624264,354230,918587,854152,686453,666163,302258,335198,567872,937644,541861,547553,561621,270869,37291,57107,895332,231709,822407,468592,885838,167252,610731,10733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001106s ]