SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002440s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509951 LIMIT 1 [ RunTime:0.004518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509951 [ RunTime:0.007609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420867,827847,454902,354448,315653,390568,581791,26359,924223,748384,25759,540762,98932,939314,651580,284995,1046486,197016,480938,507586,410159,775546,180663,334327,543882,978906,860352,501391,161727,337192,331017,37379,510832,30737,746385,76501,682782,449103,518521,619976,185249,417134,820321,988308,417369,532371,478573,456501,1016426,949733,332657,818889,455912,762470,370342,232933,521503,532965,281224,380279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]