SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555826 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555826 [ RunTime:0.002121s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472922,356256,590441,778713,362738,772377,220005,594685,566611,55246,985227,439685,575635,215369,745312,88350,519866,37488,248762,116486,361479,610124,509344,375858,896889,179783,558422,372316,1036289,70079,848988,94425,346151,984121,984949,260734,329187,561323,973676,767612,312860,729063,241949,21333,1041123,933093,88587,325004,1031850,1046399,342793,842670,824088,629948,125176,352455,590722,800651,34056,409174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]