SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003168 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003168 [ RunTime:0.002493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492028,1042970,696969,526427,959783,547760,319039,469847,147515,1045744,534616,445644,55256,874435,823333,520871,890548,410651,708214,892734,858831,321616,948176,219654,511524,779827,825103,906065,489782,76413,808005,627767,687045,835545,426174,1020608,112762,859189,619657,96716,967521,260781,548395,438489,106063,746407,878198,103505,196098,647989,499418,112882,499236,748686,945751,567640,524323,212785,302532,465073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003168 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003168 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000897s ]