SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438473 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438473 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458663,115584,570317,175399,701752,1018760,751272,678670,992512,323580,53104,96310,826134,2630,363990,447059,431741,30606,1002776,812498,588219,334383,104731,632818,150513,1041895,914113,426180,74137,492037,260144,985519,721409,450868,266150,225178,636376,795765,697453,482755,786678,40983,982789,1025292,200770,907640,488921,507716,925627,782295,979405,979649,873808,485186,633949,751379,609999,946542,222625,848160) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]