SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001540s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428954 LIMIT 1 [ RunTime:0.002405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428954 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395986,207334,732102,56321,103652,620869,1012114,426630,703843,582232,815432,919274,363462,800424,415997,419803,1481,198538,987122,707641,66811,846331,791495,238598,969771,818984,521199,552092,422791,385218,228493,366258,430434,115021,365786,595404,1035026,561939,900872,215862,271499,324257,485660,868736,43970,643072,760448,866009,728596,236518,634223,3848,94618,232741,953355,263968,193028,610791,49671,327841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]