SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 462303 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462303 [ RunTime:0.002005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151076,352095,778861,297655,662681,888336,126304,510258,542190,929201,742867,28722,102785,817743,197001,889160,291974,988507,634604,750474,658722,515085,114859,759824,146463,483079,544009,657256,99609,560203,87253,934206,55943,117999,670461,289646,403208,64423,778504,1021240,799935,655298,131015,305147,702633,253564,454545,335543,130405,49490,59487,23540,202631,140326,50939,682950,333727,100741,52617,156245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000780s ]