SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001652s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106940 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106940 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012364,560157,276813,778479,184281,965354,41180,15694,877765,498586,554097,427055,782488,28403,366561,372030,1005064,554533,450013,277507,567815,371938,632134,866057,552603,981935,752126,553415,742867,430293,369485,928252,685201,228341,133603,331429,282145,163194,52279,863320,337056,582234,164116,54593,229229,451035,303164,542147,714741,801516,978126,45745,276840,532296,923350,156163,341265,215985,348873,216603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001393s ]