SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541240 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541240 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019276,822576,585946,865487,469285,745441,423699,14737,112612,960593,382990,400381,329401,481434,36246,55955,269490,445058,702029,501769,32587,912,507543,579521,307487,765739,261372,873434,833599,371082,329783,970967,728768,733902,78980,1014970,870513,231648,860168,564831,23301,563726,650407,317591,878495,182170,653509,686670,498080,685932,629111,752198,671498,541931,282573,304109,599637,559302,213465,286860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]