SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46188 LIMIT 1 [ RunTime:0.000580s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46188 [ RunTime:0.002822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845276,439401,170927,420657,104332,519945,837761,301106,379310,724421,1034664,694038,198905,269819,490123,465420,464318,444904,704660,280211,87310,153332,7270,784545,634841,448780,275325,931842,784008,814495,897676,612636,984339,754103,672438,694787,973794,90650,309352,244618,932045,1000972,789943,12499,50131,938779,336847,465427,831592,618995,692924,927976,911406,948244,520057,641396,1046539,52480,585761,3744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]