SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510274 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510274 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109351,446609,867450,489067,987292,616024,837969,921750,300185,429173,172368,982207,764668,854292,569643,106717,229671,26708,957498,191849,935227,843583,285076,1025152,954025,585636,266654,181864,291389,810247,1032253,198977,1006399,429696,254588,343464,990783,692752,17345,28897,526859,80394,513881,379354,244023,918336,566455,549737,413505,604093,370506,544950,124620,33860,832508,365130,858337,583520,616184,557930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510274 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510274 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]