SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404940 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404940 [ RunTime:0.001612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426718,853911,414202,648764,995720,810923,500628,900031,355798,42428,687652,393069,172618,345583,1026625,112029,421003,46627,711124,457127,459716,391578,87718,89534,478259,1007775,331269,272974,991003,174124,341710,907886,356778,643814,70576,475500,1046708,743417,359996,603163,551326,895091,271208,722581,203805,245775,995608,682384,704791,18293,559698,658875,326727,766585,957743,111450,803839,368524,906254,648080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001233s ]