SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522528 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522528 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526433,348934,352697,346543,52268,304677,723610,405580,457463,390598,114768,706953,193132,910645,706002,623368,29151,33831,167357,754978,818527,134068,572891,548548,344794,687523,804501,198641,838146,439859,897409,445153,256635,539486,387853,570228,1031583,313433,516753,578834,839061,360054,1024850,527842,349187,269030,764432,73811,720988,153657,875210,646233,894880,194891,764870,317445,760238,442184,814044,627971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]