SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 577911 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 577911 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497588,935433,314162,710152,461903,855077,460476,52674,805967,10641,884536,688705,1007239,265387,479956,1006609,218637,346185,398818,897341,190782,981579,731549,145973,42295,226201,746273,143907,286402,619740,242988,937450,875290,818218,1048917,569894,315672,849355,669031,989129,525149,899134,176528,176923,910580,659298,786018,552006,553540,1005501,41100,289452,277479,880391,154623,414939,294636,809575,7610,660369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 577911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 577911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]