SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001951s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31018 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31018 [ RunTime:0.002644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467621,267464,558654,1038523,200632,801484,31228,368163,890630,793546,159499,953445,273781,212856,489009,694946,678986,343137,452467,446627,891548,1003506,898662,805179,622857,341766,336318,915551,659056,886506,155754,145796,140510,428641,367552,491927,6670,439447,966809,864673,286113,360771,54904,891853,582177,324617,229291,1012197,275011,968034,387870,249527,747264,459553,259485,131385,438919,981348,1034361,621362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000392s ]