SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016598 LIMIT 1 [ RunTime:0.000766s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016598 [ RunTime:0.002875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831594,265188,564138,909287,267056,1024622,192154,139785,829000,506537,101523,175768,409745,892159,455030,340925,29019,768101,626197,432149,196685,458913,833666,243278,495752,549421,237294,280016,20887,24210,179894,867425,73113,761242,763032,449344,66297,754602,240802,644023,384485,307483,332511,897527,105230,1025124,820459,976214,212448,22453,217835,30520,650786,1041938,420729,445316,751341,549701,941458,682778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016598 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016598 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]