SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001883 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001883 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (272552,596403,313572,505953,757497,536432,432714,94486,346420,224411,844413,9887,563942,405626,680700,556389,418730,818040,787492,657712,857821,48582,39552,799548,106241,603689,500501,959247,348065,82723,760214,921306,285664,30216,138379,548225,1019551,357286,719666,668864,1029597,1016409,442920,1034600,762157,93695,52311,289778,746593,193090,414285,380733,819859,968368,323983,269670,572009,629636,400955,923081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]