SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 980326 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 980326 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99884,121615,800418,1010074,923110,191450,1045636,1039598,896620,760394,425654,44983,476230,5152,600419,781613,354772,234494,93610,60584,401266,119818,366782,1037131,638907,486494,179148,289588,855982,535511,463579,77677,516383,475925,501354,31984,1046636,788139,1018720,63587,16077,737673,6576,482477,449309,609804,1030970,513909,584214,967536,150463,308459,625350,60830,77615,568990,719022,928943,433248,631730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 980326 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 980326 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]