SHOW FULL COLUMNS FROM `tool_category` [ RunTime:0.001285s ]
SELECT `id`,`name`,`nickname`,`pid` FROM `tool_category` WHERE `type` = 'tool' AND `status` = 'normal' AND `pid` <> 0 ORDER BY `views` DESC LIMIT 24 [ RunTime:0.009272s ]
SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103320 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103320 [ RunTime:0.002954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568749,1027209,292646,648268,757909,366678,323430,57274,443107,989716,383981,652289,1023683,971797,714176,39928,847874,144612,89105,208500,649645,313175,423122,449945,241363,106398,945379,372521,195455,291995,230731,605495,14753,379973,32611,681127,1022650,503107,794697,624229,441544,25303,702709,858696,822143,776426,112021,668300,967716,170886,819115,241180,677470,996344,482498,382735,846715,667486,12180,350566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017851s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001230s ]