SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 250018 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 250018 [ RunTime:0.002669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396880,773530,543667,60102,439908,675172,797830,706605,14295,757442,161873,253051,315978,474597,748594,576791,15606,956339,9396,888983,953232,346103,785890,627437,222403,618874,725818,537222,225540,579946,963429,634779,320635,445874,994707,189643,677259,674232,232202,640907,498320,1028227,33243,440119,252429,51056,924373,448037,131479,98677,1014221,440476,638858,404524,363219,142111,683849,460448,712942,71604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 250018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 250018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]