SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020809 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020809 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502758,623528,493475,203973,871478,284626,178579,356429,872461,671735,770317,307180,126424,921816,200983,467296,748657,308547,543646,844003,936720,281652,46819,563378,135447,650412,763197,540385,792234,61806,61117,7117,25188,3260,448584,1006487,784778,983580,900983,659064,664867,163708,996722,125724,150203,8810,977168,285431,349490,27313,129913,217246,797516,669305,357043,833491,508936,792491,140744,273350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001727s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]