SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415754 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415754 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282484,798023,607169,326508,1041590,794781,196702,858313,138190,568488,632544,158532,143831,486401,237232,440049,307920,202588,527226,362985,704578,980377,721293,359980,1021176,68484,301787,290381,238587,850520,438511,239352,874877,417715,352327,745004,479299,989238,401955,168311,254646,380677,661274,962601,399149,645452,592878,1037617,961701,771984,900434,89040,421948,600712,865232,108785,138253,712952,716019,504580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002957s ]