SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002501s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34481 LIMIT 1 [ RunTime:0.002684s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34481 [ RunTime:0.003637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617593,1038023,913377,697863,589925,52877,460342,191924,1041242,256280,283539,724387,660449,261855,741489,310470,185330,535982,717489,925483,89866,366059,244397,317246,1016898,650299,284043,759124,903191,422864,535781,834438,884195,621308,624493,139116,814297,111360,874134,867445,781240,682461,429723,486003,127034,1017551,52501,1044564,176386,156108,825543,759301,506198,39611,168136,31279,449509,36215,564018,693064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]