SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589909 LIMIT 1 [ RunTime:0.001119s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589909 [ RunTime:0.002279s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46536,573632,214077,132546,154087,652262,874267,410682,890729,1014801,92693,387133,852540,959531,885150,728103,455603,98449,778216,927772,627805,780657,1027561,512168,561652,415893,657590,536594,365786,214476,199559,878904,361198,1009567,854452,733568,557634,531267,781295,338751,933595,152293,1045982,663770,1048415,125609,247271,417741,397210,502900,499340,398323,375574,961902,677387,41869,98665,436743,973567,598127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.027376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003223s ]