SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027778 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027778 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741273,86706,689348,783611,115748,837807,696947,815387,85147,243289,241413,346988,525957,343399,625843,72954,369073,959217,409215,747783,187320,138160,636969,816391,1007334,858879,1020459,698495,342462,836094,556023,652295,459794,371794,218688,623317,247315,605446,1023527,590783,47918,952500,630790,121182,365025,160196,1015333,264402,909203,963830,714299,206859,888878,490004,127841,519691,480668,710830,267140,37640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027778 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027778 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]