SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004606s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043589 LIMIT 1 [ RunTime:0.003852s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043589 [ RunTime:0.004806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480081,730141,457380,164905,66951,429859,516665,745665,486835,100801,1012874,873833,847992,246839,451609,183629,752501,518900,973909,161452,738775,239343,827506,147689,993761,670097,988228,545619,93452,363515,612307,136204,728584,159270,499004,1000313,51303,1026118,845884,1038369,699653,141240,583467,977583,358947,243649,960410,248970,92279,892646,1018502,482808,1018977,420269,397919,899782,631832,1009181,410443,696134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000728s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001496s ]