SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510404 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510404 [ RunTime:0.002257s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287990,629616,635292,86376,756525,1017102,996315,198590,546103,362591,443699,91020,301641,424806,261143,446019,89822,35727,360833,664316,425935,683364,807675,883561,748232,853608,276812,349357,618647,890697,236543,946688,736256,648676,139329,512182,909464,672601,698451,715725,259894,587633,846543,461548,686182,1043131,238497,353949,257478,358281,310612,124553,440416,570975,762408,71753,809423,8559,232857,562888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]