SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 225104 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 225104 [ RunTime:0.003657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524895,963069,354525,795297,64451,906542,983215,991421,1042436,292491,870556,983040,520770,609614,555695,736425,440475,920310,971254,303366,863024,881823,623174,79807,637563,603404,35648,271276,426682,96100,403394,200986,278303,908500,778076,696749,259740,826671,939745,213506,98338,702625,16048,163247,1001336,172985,552648,858212,51381,819448,613436,924165,157655,388034,480795,821920,748774,323411,1006641,360414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 225104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 225104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001331s ]