SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500294 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500294 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020016,307673,937258,815602,114400,60398,805072,819888,771674,446405,263809,837641,749125,113835,738071,272533,907283,819244,625865,634501,697972,885964,869861,18135,578517,504511,834677,180473,826091,159416,1044715,551661,83358,281128,262109,964341,59907,565381,664231,788936,493554,800128,628581,689917,1033006,246093,696545,144553,585837,257450,386704,302721,56835,25440,670846,528114,254486,807172,326941,608210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001201s ]