SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515853 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515853 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894379,219893,777611,468242,896733,691533,988778,571794,788354,912730,423429,439417,57955,604870,318596,932111,757619,966572,145570,734977,888783,695517,1045718,498865,517933,105311,529537,844096,897358,752746,705565,905288,534949,516438,64244,922483,864301,600315,615816,919826,848439,1029537,314157,221861,466304,748700,697328,699113,949586,680576,872304,815989,768652,220687,972633,939348,305791,477846,670110,711680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]