SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439475 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439475 [ RunTime:0.002064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618764,574491,480815,1031432,104713,186898,705837,320039,466362,1023354,777433,418506,1020503,312043,804123,36009,323177,558332,333181,183933,806853,388334,39595,827314,438663,791021,303392,965699,44190,1015903,543976,103672,11042,55651,733795,479706,421127,985147,180832,538672,135607,562691,501900,408534,97790,138443,91152,267012,883456,191411,33564,348305,788363,474834,720634,454168,667011,719038,809506,1019644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]