SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 347871 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 347871 [ RunTime:0.003212s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467092,151477,515476,705586,607664,428500,735931,163073,821511,323857,793430,630240,627058,304777,555024,67847,96884,883084,1012508,480870,574661,564248,1875,655644,812003,563572,341594,881811,873715,14201,357329,572283,928668,693877,985462,632799,733546,53169,125159,161324,876068,800775,816364,446566,168258,832818,27607,954673,158370,555614,577924,180579,9094,557577,438619,339541,222262,327127,564752,885995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 347871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 347871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]