SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433108 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433108 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34376,311621,806945,336042,305688,350275,646446,938869,774718,171659,740536,177298,971408,540924,127513,217709,731987,108900,302502,333316,10132,51210,278784,1014224,760126,564355,524243,964473,644031,828250,860334,536135,844155,130082,696974,642704,703100,128042,872435,83554,37682,68022,847429,964968,582633,580078,139340,446670,639132,921718,582929,180906,313939,1015573,255509,249102,704690,939992,955640,906372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]