SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429116 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429116 [ RunTime:0.003642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512074,580364,318021,99299,323164,1030434,955096,1043723,217965,7011,7875,894860,620989,696892,780108,498564,394042,205594,296706,221332,742645,414658,954707,779299,211319,265451,889090,532513,49991,712974,518732,745382,693571,53275,60327,587104,737125,671068,992498,8586,762588,367152,884451,403992,776201,828461,512598,244134,194248,129693,550718,479108,30276,427788,446406,599054,583522,509629,875004,182388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]