SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555512 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555512 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111110,649561,713932,984115,22776,30084,719125,74801,561624,108034,997302,913977,295759,898351,611674,599099,994569,946785,1040687,124237,294850,184161,662835,540280,565171,937904,255790,460208,667740,389776,735128,635976,157112,615328,530625,657096,1041493,565598,550862,893796,647591,574386,488151,224246,37554,332284,477005,395491,1017549,453016,72140,988792,283675,980976,145102,507646,555254,616230,83205,686777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002059s ]