SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488095 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488095 [ RunTime:0.003872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358541,184182,418046,108087,482709,377173,716118,808310,516078,444208,296349,849980,819870,735734,100887,325290,943566,102611,791773,277706,734049,940131,905057,879820,559146,978472,975057,292865,310109,840286,732269,893016,574078,286864,67184,71192,1037776,122958,887911,1011402,944234,16390,915844,727181,477346,172220,193,161345,465347,291948,635549,412723,866596,115720,519016,1014823,114959,989522,403939,617807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488095 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488095 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]