SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194020 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194020 [ RunTime:0.003981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703940,513854,984516,458241,386836,121964,690806,668641,894791,395954,535465,310229,54088,157539,254192,501486,825395,413915,736509,143347,258773,1014412,1040525,466847,569722,78674,416085,733946,711199,76353,459861,639327,526023,412326,315473,304130,840896,371329,480224,806911,214989,297644,541793,8406,215092,980781,275291,390521,488792,619008,102850,223087,1031590,590760,469436,1047733,88644,551989,520479,583041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]