SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437052 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437052 [ RunTime:0.001962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444658,446357,291747,47651,480847,804958,231564,93499,268983,673289,593829,373142,283555,562157,899359,134540,766216,632539,1039398,486603,1041013,403090,509642,962701,852658,1030792,955159,983104,854358,205358,461842,906919,651807,726457,723458,732160,29782,1015390,543442,409770,1039478,548096,545343,675226,719053,380077,51489,356434,328503,993968,57704,671453,141157,593789,1018747,1039435,231476,864497,332274,182199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]