SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042146 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042146 [ RunTime:0.002680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733398,361467,858085,753433,258556,400955,933562,465157,127423,656074,238421,417258,1015306,535920,352860,445966,215255,597873,724767,110410,482487,938462,306809,671010,536302,825332,403854,740248,344918,1032261,463785,431983,664640,124299,449169,778707,26841,1048219,645287,950241,258505,7775,538091,87196,365704,637849,1037423,589352,269285,577994,836993,126921,591882,1047734,391794,21181,484135,815709,347470,248334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]