SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526392 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526392 [ RunTime:0.002488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134842,332565,277154,998530,749989,838237,435236,6554,224326,94078,909748,112260,530835,368771,869627,371315,865442,101692,540447,884350,351789,264160,652977,436383,263732,647675,653407,992668,132121,1030657,803850,740825,387547,291804,125898,858689,557863,977368,352854,62650,103010,573159,697289,199244,120954,913572,497265,468471,606478,423262,383786,931846,699598,55033,1941,830289,494815,446627,62272,264424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003785s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526392 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526392 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]