SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544700 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544700 [ RunTime:0.002419s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423237,620787,255056,943045,343151,923910,418243,828444,194218,1028440,821318,542218,955281,312392,682454,574099,474361,226517,971567,329328,624311,395399,251163,444106,901086,749785,896017,886050,98190,964143,913401,56436,565440,254101,838253,138121,488712,106542,762800,944159,486218,437375,151686,809893,1002621,59850,184404,687441,776100,65068,252319,97032,724535,554347,129249,390704,615775,400833,581318,52496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544700 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544700 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001110s ]