SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506558 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506558 [ RunTime:0.002520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339894,870712,1009222,692675,1033894,917860,872600,694955,33302,898326,865746,22247,373171,800525,189169,130665,960260,667038,470492,1017312,124323,507109,169469,689451,503896,950290,296827,89698,917141,128110,333528,541161,126286,435289,639224,201742,199378,986275,736681,242078,957889,782950,119465,199983,390278,113354,428591,105905,865135,401707,677623,552809,801531,337300,957335,154174,334377,996533,388844,32529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506558 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506558 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]