SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519918 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519918 [ RunTime:0.004194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455308,333409,340065,165576,205740,745538,334643,415535,989696,302467,128525,551594,547758,798656,218059,645265,1002353,141446,802219,693638,880264,900411,299278,570721,773769,792178,619784,929620,613953,548048,215663,266960,879695,921710,665508,483477,36823,295794,156871,247533,482889,520306,527460,879991,883790,835213,365682,387044,224791,827575,212497,219058,823490,631102,36420,75687,877857,887623,396892,248463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]