SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540863 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540863 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4592,629041,523935,139357,363979,181350,253624,603192,615465,331610,153804,422489,91350,451862,776866,482531,360106,886815,910049,993804,473741,742069,955228,552919,1010222,431139,938049,1023855,864944,256234,974735,797825,6478,867762,507513,906361,310913,568599,988753,150511,310935,1005935,711771,175509,720175,565649,15813,724852,590984,600745,26279,570883,750529,689833,125388,497450,74063,963911,140422,559964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]