SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002740s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418368 LIMIT 1 [ RunTime:0.003686s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418368 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371342,992736,638909,550995,738483,21865,172261,253019,715987,1018004,825564,822783,757114,812626,22568,1044078,695129,827317,564750,100718,398718,826380,163623,281827,458183,726125,603000,258466,473287,139062,557973,669937,134142,261277,531473,351986,812611,955561,852510,489693,504889,6194,397072,425497,375123,332576,50185,152879,300374,30299,723324,744341,837591,337204,500095,201241,893078,491637,698280,699898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000803s ]