SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107382 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107382 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528213,633344,982137,258591,532454,321134,192733,3878,750264,70410,725623,337527,412658,638945,164516,827181,417473,401501,212547,239593,605125,984558,673916,849676,763463,751981,747576,963641,943798,114917,416001,604106,934841,64870,779694,511125,875000,751886,688496,107054,671198,911577,237078,869497,1011942,817422,728162,84456,415754,920406,146225,834948,727288,723554,796215,314898,960130,597071,77130,286322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107382 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107382 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]