SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 462300 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462300 [ RunTime:0.002861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (22446,58231,432133,689461,1014330,414411,1036237,24984,120359,727137,667442,644208,701063,302699,881060,968909,16383,184810,729710,210684,117618,395789,1022435,235377,947164,881578,156707,521770,235633,642914,103208,891644,47918,34367,664905,844944,111761,491036,957362,741229,1009488,917012,735952,133082,1002254,997493,256855,829040,24576,771881,965378,499975,594596,282392,589796,201284,751924,358239,272097,842086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]