SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507301 LIMIT 1 [ RunTime:0.000611s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507301 [ RunTime:0.004892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438396,179611,559236,529170,964677,8263,434396,874577,248951,615647,322883,222378,526225,203843,331562,438792,314465,562189,685106,654119,734093,230128,283675,633944,243916,666807,27040,841275,629473,393658,589087,579727,456526,815051,317692,778385,452430,887455,185078,721943,940023,789030,274900,722805,1002949,1046599,762869,72107,777223,93778,1028600,504770,708603,139437,696631,30097,420927,198212,644162,127139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]