SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467945 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467945 [ RunTime:0.002518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (956017,744959,462979,74864,202427,787395,386364,120141,569804,663961,796792,78068,372782,540539,186657,394136,379191,566365,454445,18076,777592,220222,20797,438015,31624,342363,903076,99420,690875,243964,298427,201666,497859,275731,502206,512312,735750,294151,631944,611941,331983,714829,53656,793407,201640,103865,902121,640373,140500,99111,509905,49991,683675,351928,750134,977936,831131,686389,794401,974710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]