SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468540 LIMIT 1 [ RunTime:0.000492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468540 [ RunTime:0.001853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (949091,202024,476596,215454,543033,725851,130723,965269,989357,9978,112860,410107,955142,134049,279735,742260,574101,371758,484580,987199,673842,386911,323911,1004226,781482,480006,522251,223454,622788,818661,434231,114971,437665,63191,573530,973914,867559,112760,511690,798375,324701,867468,993474,396896,429467,993585,356480,538115,215381,422780,644787,822858,747114,170696,140198,179648,747198,589445,1040557,457273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]