SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289315 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289315 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199654,456299,575748,996105,669361,175530,1006826,773,808428,128182,923557,905121,394953,405801,963743,395461,111511,716098,178351,699017,1043546,872867,872365,512112,1009597,1019503,988127,762604,164156,731892,316419,243749,831842,362718,464381,869441,961361,330983,313474,346819,567549,419078,945717,671639,296801,774205,484988,128617,284680,561041,811465,853972,900698,601907,723999,131,921567,1026567,156648,980095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]