SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340476 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340476 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020877,946013,465685,432078,834711,164270,971390,1039275,968485,1016652,74554,943210,86175,175698,822061,187876,789354,51070,900230,112706,568093,302762,957840,1043709,976701,631595,1005824,840526,925678,473250,582614,53656,589510,279221,83413,270660,915329,57134,534455,420248,258832,544482,504529,937327,394058,154142,431117,376695,679929,341961,423343,89803,450283,582662,454127,313326,941836,788699,299260,976075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001823s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340476 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340476 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000938s ]