SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538503 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538503 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529227,77518,239417,90472,1033109,302555,408654,183080,865959,809032,897020,503272,1041246,68957,178543,270146,155633,310516,645899,633545,535296,826259,65870,1006647,246119,950370,1004290,959092,463546,249791,584228,137847,184930,207751,1046020,426166,62938,582120,1028182,548610,1002746,597536,85644,948837,187679,333357,954532,418637,712902,569871,415262,203775,276776,900155,1007715,162691,217995,107391,25795,310039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]